<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
  "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head><title></title>
<link href="../style/ebook.css" type="text/css" rel="stylesheet">
</head>
<body>
<h1>Data Profiling</h1>
<p>Part of being productive with data is having the right weapons to
profile the data you are working with. Airflow provides a simple query
interface to write SQL and get results quickly, and a charting application
letting you visualize data.</p>
<div class="section" id="adhoc-queries">
<h2 class="sigil_not_in_toc">Adhoc Queries</h2>
<p>The adhoc query UI allows for simple SQL interactions with the database
connections registered in Airflow.</p>
<img alt="https://airflow.apache.org/_images/adhoc.png" src="../img/bfbf60f9689630d6aa1f46aeab1e6cf0.jpg">
</div>
<div class="section" id="charts">
<h2 class="sigil_not_in_toc">Charts</h2>
<p>A simple UI built on top of flask-admin and highcharts allows building
data visualizations and charts easily. Fill in a form with a label, SQL,
chart type, pick a source database from your environment&#x2019;s connections,
select a few other options, and save it for later use.</p>
<p>You can even use the same templating and macros available when writing
airflow pipelines, parameterizing your queries and modifying parameters
directly in the URL.</p>
<p>These charts are basic, but they&#x2019;re easy to create, modify and share.</p>
<div class="section" id="chart-screenshot">
<h3 class="sigil_not_in_toc">Chart Screenshot</h3>
<img alt="https://airflow.apache.org/_images/chart.png" src="../img/a7247daabfaa0606cbb0d05e511194db.jpg">
</div>
<hr class="docutils">
<div class="section" id="chart-form-screenshot">
<h3 class="sigil_not_in_toc">Chart Form Screenshot</h3>
<img alt="https://airflow.apache.org/_images/chart_form.png" src="../img/a40de0ada10bc0250de4b6c082cb7660.jpg">
</div>
</div>
</body>
</html>